How to: Combine one or more tables into another new table.
Solution:
Create a new table and copy and paste the other table data into the newly created one using 'Paste Table As'.
NOTE: The tables to combine must have the same field names and data types in the same order before proceeding.
1) If the Database window is not activated, activate the Database window.
2) Click the 'Tables' tab in the Database window.
Tables tab
3) Select one of the existing tables. (The table name is highlighted.)
4) Select the 'Edit' menu and select 'Copy'.
5) Select the 'Edit' menu and select 'Paste'. (The Paste Table As dialog box appears.)
6) Type the name of the new table in the 'Table Name' box.
7) Select the 'Structure and Data' radio button.
8) Click 'OK'. (The new table is created with the data from the selected table.)
9) Select one of the other existing tables to be combined into the new table.
10) Select the 'Edit' menu and select 'Copy'.
11) Select the 'Edit' menu and select 'Paste'. (The Paste Table As dialog box appears.)
12) Type the name of the newly created table in the 'Table Name' box.
13) Select the 'Append Data to Existing Table' radio button.
14) Click 'OK'. (The data is copied to the newly created table.)
15) Repeat steps 9) through 14) for each additional table.
